/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.compra.sql;

/**
 *
 * @author JM
 */
public class SQLSucursal {

    public static final String insertSucursal = "INSERT INTO SUCURSAL(nombre_s,direccion_s,fax_s)VALUES(?,?,?)";
    public static final String updateSucursal = "UPDATE SUCURSAL set nombre_s=?,direccion_s=?,fax_s=? WHERE codigo_s=?";

    public static final String ELIMINAR = "DELETE FROM sucursal WHERE codigo_s=?";
    public static final String All = "SELECT * FROM sucursal order by nombre_s";

    public static final String insertTelefonos = "INSERT INTO TELEFONO_SUCURSAL (codigo_s,telefono_ts,tipo_ts)VALUES(?,?,?)";
    public static final String updateTelefonos = "UPDATE TELEFONO_SUCURSAL SET codigo_s=?,telefono_ts=?,tipo_ts=? WHERE codigo_ts=?";
}
